Databases |

This information is relevant only if you own a Fisa Logger Licence. See Fisa Logger

Databases
Logger Master.cmb
Logger.cmb
Structure
How Data are Created and Saved
Queries
Query Example
Databases

Fisa Logger databases have the extension *.cmb. File Extensions

These databases are only used for saving Production data with Fisa Logger Licence.

The databases can be opened with Access 2000 (included in Microsoft Office 2000 Professional) or later. By default, the databases are password protected. You can change or remove the password. How to change the Password

Fisa Logger works with two databases:

- Logger Master.cmb
- Logger.cmb

  Logger Master serves as the template for creating a new Installation.cmb (working database). Logger.cmb will be named as your Installation name, eg My First Installation.cmb. The structure of the Logger.cmb will therefore be the same as for Logger Master.cmb, except for the table Operators which exists only in the Logger Master.cmb.
  Logger Master.cmb

  Located in the application path

  You need to know the password for Logger Master.cmb to enter in Supervisor Mode. Supervisor Mode
  Logger.cmb

  Located in the same path as the *.cmg file.
  Normally \Fisa Software\Fisa Project\Installations\MyFirst Installation.cmb.
  File Extensions

  This database is created as a copy of Logger Master.cmb whenever creating a new installation. The Logger.cmb could also be created if it is not found at the same location as the *.cmg file.

  The Logger.cmb can have a different password than the one in Logger Master.cmb.
  Structure

  How Data are Created and Saved

  - When an operator presses Start Logger and logging starts, a new Session is created. Start Logger
  - During the session different events create new data objects:
    1. A basket is detected on a Loading position - creates a new basket.
    2. A basket is put in a position - creates a new visit. Visit Details
    3. The operator clicks on the Intervention menu - creates a new intervention. How to register an Intervention
    4. An instrument reports an off range value - creates a new alarm.
    5. A maintenance becomes due - creates a new alarm.
  - Baskets and their corresponding visits are saved whenever the basket is put on an unloading position.
  - Alarms are continuously saved.
  - Interventions are saved as they are defined.
  - Times of activation of accessories connected to physical outputs are registered for each visit. See also Outputs Connections
  Queries

  The most important queries for data mining in the Logger database are already included in Fisa Logger. The Baskets Analyzer

  This does not exclude that you might want to prepare your own, more refined, queries based on the structure described above.
  Query Example

  A query like this one is easily constructed in the Access 2000 Query design interface:

  The produced SQL string looks like this:

  SELECT Baskets.*, Baskets.Barcode FROM ((Operators INNER JOIN [Session] ON Operators.Operator = Session.Operator) INNER JOIN Baskets ON Session.Counter = Baskets.SessionID) INNER JOIN Visits ON Baskets.Counter = Visits.BasketsID WHERE (((Baskets.Barcode) Like "????###AB*"));